package com.lzw.DailyAudit.mapper;


import com.baomidou.dynamic.datasource.annotation.DS;
import com.hooya.fa.eu.biz.DailyAudit.entity.dto.TempKcjlDailyHyDTO;
import com.hooya.fa.eu.biz.DailyAudit.entity.dto.ZyDataDTO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author author
 * @since 2025-09-15
 */
@Mapper
public interface DailyTempZyjlMapper {

	@DS("fa_eu_daily")
	@Select("SELECT sum(cgsl) as sl, cpbh, zcck, zlck, htrq as date, frombelongs, tobelongs FROM temp_zyjl WHERE htrq = #{currentDate} AND cpbh <> 'HW63759WH' GROUP BY cpbh,zcck,zlck,htrq,frombelongs,tobelongs")
	List<TempKcjlDailyHyDTO> getZyjlData(String currentDate);

	@DS("fa_eu_daily")
	List<ZyDataDTO> getZyInData(@Param("currentDate") String currentDate);

	@DS("fa_eu_daily")
	List<ZyDataDTO> getZyOutData(@Param("currentDate") String currentDate);

	@DS("fa_eu_daily")
	List<ZyDataDTO> getZyFirstDay(@Param("curMonthFirstDay") String curMonthFirstDay, @Param("currentDate") String currentDate);
}
